You are here : Materials > Material Masters > Formula Builder

Formula Builder

 

In an engineering manufacturing scenario, there may exist certain items that are consumed in terms of their dimensions. Such items are termed as Dimension Items in IMMS. Dimension Items can belong to various combinations of Material and Item Sub-Class with each having same or different dimension heads.

 

This option allows to add and maintain Dimension Heads as well as formula to be used for such Items. The Formula defined here is further used to calculate Weight of the Dimension Item by multiplying it with the Density of the Item.

 

CollapsedClick for Example

 

A list of all Materials of Construction along with the Item Sub Classes for which Formula has already been defined is displayed as follows -

Search:

Enter any text you want to search in the list below. The search is applicable to all columns of the list. Once the text is entered, press <ENTER> key. As a result, the list will be refreshed with all those records that contain the entered text fully or partially. In order to go back to the original list, remove the text from the box and press <ENTER> key again.

 

Formulas can be added, edited, deleted and viewed provided the Role associated with the currently logged-in user through User Management has the respective rights to do so. These actions are explained as under -

 

To 'Add' a Formula, click on the button and to 'Edit' a Formula of an MOC, click on the icon on its corresponding record. To view the Formula of an MOC, <DoubleClick> on that record. As a result, following screen will be displayed -

Screen Layout of Formula Builder

Field Description of Formula Builder

Material:

Denotes the Material of the Dimension Item.

 

While 'Adding', click on the field to access a list of existing Materials defined though Codes Master Entry (Code Type = 'MC') option of Administrator Tools Module. Select your desired Material from the list by scrolling down to it and pressing <ENTER>. Alternatively you can also enter the Material Code.

 

In case of 'Edit', 'View' and 'Delete' modes, Material of the selected record will be displayed. You can NOT change it in 'Edit' mode.

 

Item Sub Class:

Denotes the Sub-Class of the Dimension Item.

 

While 'Adding', click on the field to access a list of existing Sub-Classes defined though Class/Sub-Class Master option of Administrator Tools Module. Select your desired Sub-Class from the list by scrolling down to it and pressing <ENTER>. Alternatively you can also enter the Sub-Class Code.

Please note that while 'Adding', only those Sub-Classes will be displayed/accepted for which the flag 'Do you require Dimensions for Material Items?' is set as 'Yes' through Class/Sub-Class Master option of Administrator Tools Module.

 

In case of 'Edit', 'View' and 'Delete' modes, Item Sub Class of the selected record will be displayed. You can NOT change it in 'Edit' mode.

 

Dimension D1:

(Type : Alphanumeric, Length : 10)

 

Denotes the Head of Dimension 1.

 

While 'Adding' a new Dimension Item, enter the Heading for Dimension 1.

 

In case of 'Edit', 'View' and 'Delete' modes, Dimension D1 of the selected record will be displayed. You can change it in 'Edit' mode.

 

Measure in:

Denotes the Unit of Measurement for Dimension 1.

 

While 'Adding', click on the field to access a list of existing Unit of Measurement defined though Codes Master Entry (Code Type = 'UM') option of Administrator Tools Module. Select your desired UOM from the list by scrolling down to it and pressing <ENTER>.

 

In case of 'Edit', 'View' and 'Delete' modes, the 'Measure in' will be displayed automatically for the selected record. You can change it in 'Edit' mode.

 

Allow to Change?

Denotes whether the value of Dimension 1 can be changed or not.

 

If the flag is 'On', a user can change the value of Dimension1 of the Item during Indent creation and Purchase Order generation.

 

If the flag is 'Off', a user can NOT change the value of Dimension1.

 

In case of 'Edit', 'View' and 'Delete' modes, the status of this flag will be displayed automatically for the selected record. You can change it in 'Edit' mode.

 

Print:

Denotes whether the value of Dimension 1 can be printed or not.

 

If the flag is 'On', the value of Dimension D1 will be printed on certain documents and reports.

 

If the flag is 'Off', the value of Dimension D1 will NOT be printed on any documents and reports.

 

In case of 'Edit', 'View' and 'Delete' modes, the status of this flag will be displayed automatically for the selected record. You can change it in 'Edit' mode.

 

Dimension D2:

(Type : Alphanumeric, Length : 10)

 

Denotes the Head of Dimension 2.

 

While 'Adding' a new Dimension Item, enter the Heading for Dimension 2.

 

In case of 'Edit', 'View' and 'Delete' modes, Dimension D2 will be displayed automatically for the selected record. You can change it in 'Edit' mode.

 

Measure in:

Denotes the Unit of Measurement for Dimension 2.

 

While 'Adding', click on the field to access a list of existing Unit of Measurement defined though Codes Master Entry (Code Type = 'UM') option of Administrator Tools Module. Select your desired UOM from the list by scrolling down to it and pressing <ENTER>.

 

In case of 'Edit', 'View' and 'Delete' modes, the 'Measure in' will be displayed automatically for the selected record. You can change it in 'Edit' mode.

 

Allow to Change?

Denotes whether the value of Dimension 2 can be changed or not.

 

If the flag is 'On', a user can change the value of Dimension2 of the Item during Indent creation and Purchase Order generation.

 

If the flag is 'Off', a user can NOT change the value of Dimension2.

 

In case of 'Edit', 'View' and 'Delete' modes, the status of this flag will be displayed automatically for the selected record. You can change it in 'Edit' mode.

 

Print:

Denotes whether the value of Dimension 2 can be printed or not.

 

If the flag is 'On', the value of Dimension D2 will be printed on certain documents and reports.

 

If the flag is 'Off', the value of Dimension D2 will NOT be printed on any documents and reports.

 

In case of 'Edit', 'View' and 'Delete' modes, the status of this flag will be displayed automatically for the selected record. You can change it in 'Edit' mode.

 

Dimension D3:

(Type : Alphanumeric, Length : 10)

 

Denotes the Head of Dimension 3.

 

While 'Adding' a new Dimension Item, enter the Heading for Dimension 3.

 

In case of 'Edit', 'View' and 'Delete' modes, Dimension D3 will be displayed automatically for the selected record. You can change it in 'Edit' mode.

 

Measure in:

Denotes the Unit of Measurement for Dimension 3.

 

While 'Adding', click on the field to access a list of existing Unit of Measurement defined though Codes Master Entry (Code Type = 'UM') option of Administrator Tools Module. Select your desired UOM from the list by scrolling down to it and pressing <ENTER>.

 

In case of 'Edit', 'View' and 'Delete' modes, the 'Measure in' will be displayed automatically for the selected record. You can change it in 'Edit' mode.

 

Allow to Change?

Denotes whether the value of Dimension 3 can be changed or not.

 

If the flag is 'On', a user can change the value of Dimension3 of the Item during Indent creation and Purchase Order generation.

 

If the flag is 'Off', a user can NOT change the value of Dimension3.

 

In case of 'Edit', 'View' and 'Delete' modes, the status of this flag will be displayed automatically for the selected record. You can change it in 'Edit' mode.

 

Print:

Denotes whether the value of Dimension 3 can be printed or not.

 

If the flag is 'On', value of Dimension D3 will be printed on certain documents and reports.

 

If the flag is 'Off', value of Dimension D3 will NOT be printed on any documents and reports.

 

In case of 'Edit', 'View' and 'Delete' modes, the status of this flag will be displayed automatically for the selected record. You can change it in 'Edit' mode.

 

Formula:

This field displays the formula to be used for the Dimension Item.

 

This field always remains disabled as it is only used to display the Formula.

 

While 'Adding' a new Dimension Item, this field remains empty.

 

In case of 'Edit', 'View' and 'Delete' modes, Formula for the selected Material and Sub-Class will be displayed automatically.

 

Dimensionaaaa Operation aaaaConstant

Create the Formula to be used for the Dimension Item using these fields as follows-

  1. First click on the small down arrow on the 'Dimension' field. Now select either 'D1', 'D2' or 'D3' as per the formula.
  2. Now select the operator to be used in the Formula by selecting either '+', '-', '*' or '/' from the 'Operator' field.
  3. Again go back to the 'Dimension' field to select the next Dimension and so on and so forth.

As you go on creating the Formula, it will appear in the 'Formula' field.

 

You can click on 'Reset' button to clear the existing Formula and create a new one.

 

Once you have entered all the information, click on 'Save' button to save or 'Cancel' button to discard. The control will go back to the list.